Overview
Brought to you by YData
Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 18396 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 682.7 KiB |
| Average record size in memory | 38.0 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 8 |
num_100 is highly overall correlated with num_unq and 1 other fields | High correlation |
num_25 is highly overall correlated with num_50 and 1 other fields | High correlation |
num_50 is highly overall correlated with num_25 | High correlation |
num_unq is highly overall correlated with num_100 and 2 other fields | High correlation |
total_secs is highly overall correlated with num_100 and 1 other fields | High correlation |
num_75 is highly skewed (γ1 = 24.2892902) | Skewed |
num_985 is highly skewed (γ1 = 34.34348763) | Skewed |
num_25 has 4970 (27.0%) zeros | Zeros |
num_50 has 9157 (49.8%) zeros | Zeros |
num_75 has 10345 (56.2%) zeros | Zeros |
num_985 has 10033 (54.5%) zeros | Zeros |
num_100 has 484 (2.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-15 22:20:09.525421 |
|---|---|
| Analysis finished | 2025-03-15 22:20:23.422516 |
| Duration | 13.9 seconds |
| Software version | ydata-profiling vv4.14.0 |
| Download configuration | config.json |
Variables
msno
Text
| Distinct | 18209 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 287.4 KiB |
Length
| Max length | 44 |
|---|---|
| Median length | 44 |
| Mean length | 44 |
| Min length | 44 |
Unique
| Unique | 18025 ? |
|---|---|
| Unique (%) | 98.0% |
Sample
| 1st row | WvbtqrNMRNsw8d16Q8bXCnQ5Doy6EpRZJsJukiPiPQA= |
|---|---|
| 2nd row | 45G4M13aqDprqi2Qc94cqeKN3if+bYOtwX877yWSN78= |
| 3rd row | tYCa8ga3FGwCXQRUqhd/mf2tkVrzRIkT/FY/B1MKZVE= |
| 4th row | iV5B5c2Mnm9J3/MYJhjcvdCGMb54O+ZmYwxzLlkh4HY= |
| 5th row | v/zXD/h3eH0A/oomcOo24hPP+xjKvrBuCtA01gbUXQQ= |
| Value | Count | Frequency (%) |
| bavrqnz7x89pl5dsgqrbo52/4vvmqdim/jjcqjn0aqy | 3 | < 0.1% |
| ss/6ncfhmei82z/mzv5+ha99y2ebmvyf+w0gzzo4frg | 3 | < 0.1% |
| bakcjzxsmcjtolpenwularo4g0n0hg9kwbsmgx8qrn0 | 3 | < 0.1% |
| l0bk3qozevb0csylngtu99ucgmfzowcjwgk+qbl97l8 | 2 | < 0.1% |
| ggchieqc2u5gawlbrkbjdmqhf20jtezmz7wbapllumi | 2 | < 0.1% |
| maqcn/fzlwgdagpskk8kjwzmycyfzwfim1tgz28w+qy | 2 | < 0.1% |
| ay0nm//wvt3k+pvidmdidbtifmccmyf634gkntccpre | 2 | < 0.1% |
| hb3cpqzrstxhogq1ag5hhww9cxpoxwency8ldlt+czc | 2 | < 0.1% |
| 6xp5ddodwu1hymmus2yc8vcjucrhfezuoxztj+oms78 | 2 | < 0.1% |
| rd5alwmicnrev5jmg0xenkco41qtzcmtmzx9mdullms | 2 | < 0.1% |
| Other values (18199) | 18373 |
Most occurring characters
| Value | Count | Frequency (%) |
| = | 18396 | 2.3% |
| g | 13411 | 1.7% |
| Q | 13359 | 1.7% |
| U | 13308 | 1.6% |
| M | 13293 | 1.6% |
| 8 | 13290 | 1.6% |
| I | 13273 | 1.6% |
| E | 13265 | 1.6% |
| k | 13242 | 1.6% |
| o | 13238 | 1.6% |
| Other values (55) | 671349 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 321637 | |
| Lowercase Letter | 320781 | |
| Decimal Number | 124228 | 15.3% |
| Math Symbol | 30680 | 3.8% |
| Other Punctuation | 12098 | 1.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| g | 13411 | 4.2% |
| k | 13242 | 4.1% |
| o | 13238 | 4.1% |
| s | 13225 | 4.1% |
| c | 13187 | 4.1% |
| w | 13159 | 4.1% |
| l | 12223 | 3.8% |
| a | 12202 | 3.8% |
| h | 12196 | 3.8% |
| p | 12190 | 3.8% |
| Other values (16) | 192508 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 13359 | 4.2% |
| U | 13308 | 4.1% |
| M | 13293 | 4.1% |
| I | 13273 | 4.1% |
| E | 13265 | 4.1% |
| Y | 13077 | 4.1% |
| A | 12810 | 4.0% |
| S | 12279 | 3.8% |
| T | 12185 | 3.8% |
| W | 12148 | 3.8% |
| Other values (16) | 192640 |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 13290 | |
| 0 | 13183 | |
| 4 | 13153 | |
| 5 | 12211 | |
| 9 | 12197 | |
| 1 | 12118 | |
| 3 | 12089 | |
| 6 | 12075 | |
| 7 | 11970 | |
| 2 | 11942 |
Math Symbol
| Value | Count | Frequency (%) |
| = | 18396 | |
| + | 12284 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 12098 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 642418 | |
| Common | 167006 | 20.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| g | 13411 | 2.1% |
| Q | 13359 | 2.1% |
| U | 13308 | 2.1% |
| M | 13293 | 2.1% |
| I | 13273 | 2.1% |
| E | 13265 | 2.1% |
| k | 13242 | 2.1% |
| o | 13238 | 2.1% |
| s | 13225 | 2.1% |
| c | 13187 | 2.1% |
| Other values (42) | 509617 |
Common
| Value | Count | Frequency (%) |
| = | 18396 | |
| 8 | 13290 | 8.0% |
| 0 | 13183 | 7.9% |
| 4 | 13153 | 7.9% |
| + | 12284 | 7.4% |
| 5 | 12211 | 7.3% |
| 9 | 12197 | 7.3% |
| 1 | 12118 | 7.3% |
| / | 12098 | 7.2% |
| 3 | 12089 | 7.2% |
| Other values (3) | 35987 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 809424 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| = | 18396 | 2.3% |
| g | 13411 | 1.7% |
| Q | 13359 | 1.7% |
| U | 13308 | 1.6% |
| M | 13293 | 1.6% |
| 8 | 13290 | 1.6% |
| I | 13273 | 1.6% |
| E | 13265 | 1.6% |
| k | 13242 | 1.6% |
| o | 13238 | 1.6% |
| Other values (55) | 671349 |
date
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20170316 |
| Minimum | 20170301 |
|---|---|
| Maximum | 20170331 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 215.6 KiB |
Quantile statistics
| Minimum | 20170301 |
|---|---|
| 5-th percentile | 20170302 |
| Q1 | 20170308 |
| median | 20170316 |
| Q3 | 20170324 |
| 95-th percentile | 20170330 |
| Maximum | 20170331 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.9393769 |
|---|---|
| Coefficient of variation (CV) | 4.4319469 × 10-7 |
| Kurtosis | -1.2046072 |
| Mean | 20170316 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.0060746825 |
| Sum | 3.7105313 × 1011 |
| Variance | 79.91246 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20170322 | 647 | 3.5% |
| 20170330 | 640 | 3.5% |
| 20170316 | 636 | 3.5% |
| 20170311 | 629 | 3.4% |
| 20170321 | 626 | 3.4% |
| 20170306 | 620 | 3.4% |
| 20170307 | 611 | 3.3% |
| 20170314 | 609 | 3.3% |
| 20170329 | 606 | 3.3% |
| 20170327 | 602 | 3.3% |
| Other values (21) | 12170 |
| Value | Count | Frequency (%) |
| 20170301 | 579 | |
| 20170302 | 593 | |
| 20170303 | 584 | |
| 20170304 | 583 | |
| 20170305 | 572 | |
| 20170306 | 620 | |
| 20170307 | 611 | |
| 20170308 | 580 | |
| 20170309 | 552 | |
| 20170310 | 596 |
| Value | Count | Frequency (%) |
| 20170331 | 560 | |
| 20170330 | 640 | |
| 20170329 | 606 | |
| 20170328 | 593 | |
| 20170327 | 602 | |
| 20170326 | 591 | |
| 20170325 | 587 | |
| 20170324 | 594 | |
| 20170323 | 584 | |
| 20170322 | 647 |
num_25
Real number (ℝ)
High correlation  Zeros 
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.1488911 |
| Minimum | 0 |
|---|---|
| Maximum | 353 |
| Zeros | 4970 |
| Zeros (%) | 27.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 179.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 7 |
| 95-th percentile | 25 |
| Maximum | 353 |
| Range | 353 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 12.278412 |
|---|---|
| Coefficient of variation (CV) | 1.9968498 |
| Kurtosis | 102.23048 |
| Mean | 6.1488911 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 7.1209005 |
| Sum | 113115 |
| Variance | 150.7594 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4970 | |
| 1 | 2752 | |
| 2 | 1919 | 10.4% |
| 3 | 1376 | 7.5% |
| 4 | 1068 | 5.8% |
| 5 | 836 | 4.5% |
| 6 | 679 | 3.7% |
| 7 | 545 | 3.0% |
| 8 | 518 | 2.8% |
| 9 | 423 | 2.3% |
| Other values (117) | 3310 |
| Value | Count | Frequency (%) |
| 0 | 4970 | |
| 1 | 2752 | |
| 2 | 1919 | 10.4% |
| 3 | 1376 | 7.5% |
| 4 | 1068 | 5.8% |
| 5 | 836 | 4.5% |
| 6 | 679 | 3.7% |
| 7 | 545 | 3.0% |
| 8 | 518 | 2.8% |
| 9 | 423 | 2.3% |
| Value | Count | Frequency (%) |
| 353 | 1 | |
| 292 | 1 | |
| 289 | 1 | |
| 198 | 1 | |
| 195 | 1 | |
| 188 | 1 | |
| 178 | 1 | |
| 175 | 1 | |
| 165 | 1 | |
| 160 | 1 |
num_50
Real number (ℝ)
High correlation  Zeros 
| Distinct | 58 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4797239 |
| Minimum | 0 |
|---|---|
| Maximum | 143 |
| Zeros | 9157 |
| Zeros (%) | 49.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 179.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 143 |
| Range | 143 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.8289568 |
|---|---|
| Coefficient of variation (CV) | 2.5876158 |
| Kurtosis | 342.43977 |
| Mean | 1.4797239 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 13.747568 |
| Sum | 27221 |
| Variance | 14.66091 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9157 | |
| 1 | 4232 | |
| 2 | 2018 | 11.0% |
| 3 | 988 | 5.4% |
| 4 | 642 | 3.5% |
| 5 | 360 | 2.0% |
| 6 | 242 | 1.3% |
| 7 | 189 | 1.0% |
| 8 | 123 | 0.7% |
| 9 | 77 | 0.4% |
| Other values (48) | 368 | 2.0% |
| Value | Count | Frequency (%) |
| 0 | 9157 | |
| 1 | 4232 | |
| 2 | 2018 | 11.0% |
| 3 | 988 | 5.4% |
| 4 | 642 | 3.5% |
| 5 | 360 | 2.0% |
| 6 | 242 | 1.3% |
| 7 | 189 | 1.0% |
| 8 | 123 | 0.7% |
| 9 | 77 | 0.4% |
| Value | Count | Frequency (%) |
| 143 | 1 | |
| 133 | 1 | |
| 120 | 1 | |
| 114 | 1 | |
| 85 | 1 | |
| 77 | 1 | |
| 73 | 1 | |
| 71 | 2 | |
| 69 | 1 | |
| 67 | 1 |
num_75
Real number (ℝ)
Skewed  Zeros 
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.93705153 |
| Minimum | 0 |
|---|---|
| Maximum | 149 |
| Zeros | 10345 |
| Zeros (%) | 56.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 179.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 149 |
| Range | 149 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.2494009 |
|---|---|
| Coefficient of variation (CV) | 2.4005093 |
| Kurtosis | 1255.1908 |
| Mean | 0.93705153 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.28929 |
| Sum | 17238 |
| Variance | 5.0598046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10345 | |
| 1 | 4259 | |
| 2 | 1871 | 10.2% |
| 3 | 879 | 4.8% |
| 4 | 399 | 2.2% |
| 5 | 248 | 1.3% |
| 6 | 124 | 0.7% |
| 7 | 95 | 0.5% |
| 8 | 45 | 0.2% |
| 9 | 31 | 0.2% |
| Other values (22) | 100 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 10345 | |
| 1 | 4259 | |
| 2 | 1871 | 10.2% |
| 3 | 879 | 4.8% |
| 4 | 399 | 2.2% |
| 5 | 248 | 1.3% |
| 6 | 124 | 0.7% |
| 7 | 95 | 0.5% |
| 8 | 45 | 0.2% |
| 9 | 31 | 0.2% |
| Value | Count | Frequency (%) |
| 149 | 1 | |
| 82 | 1 | |
| 80 | 1 | |
| 61 | 1 | |
| 51 | 1 | |
| 39 | 2 | |
| 37 | 1 | |
| 31 | 1 | |
| 25 | 1 | |
| 24 | 2 |
num_985
Real number (ℝ)
Skewed  Zeros 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0839856 |
| Minimum | 0 |
|---|---|
| Maximum | 219 |
| Zeros | 10033 |
| Zeros (%) | 54.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 179.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 219 |
| Range | 219 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.6303008 |
|---|---|
| Coefficient of variation (CV) | 3.3490303 |
| Kurtosis | 1749.8834 |
| Mean | 1.0839856 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.343488 |
| Sum | 19941 |
| Variance | 13.179084 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10033 | |
| 1 | 4293 | |
| 2 | 1893 | 10.3% |
| 3 | 904 | 4.9% |
| 4 | 463 | 2.5% |
| 5 | 281 | 1.5% |
| 6 | 164 | 0.9% |
| 7 | 116 | 0.6% |
| 8 | 63 | 0.3% |
| 9 | 51 | 0.3% |
| Other values (32) | 135 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 10033 | |
| 1 | 4293 | |
| 2 | 1893 | 10.3% |
| 3 | 904 | 4.9% |
| 4 | 463 | 2.5% |
| 5 | 281 | 1.5% |
| 6 | 164 | 0.9% |
| 7 | 116 | 0.6% |
| 8 | 63 | 0.3% |
| 9 | 51 | 0.3% |
| Value | Count | Frequency (%) |
| 219 | 1 | |
| 209 | 1 | |
| 181 | 1 | |
| 127 | 1 | |
| 81 | 1 | |
| 75 | 2 | |
| 63 | 2 | |
| 60 | 1 | |
| 57 | 1 | |
| 47 | 1 |
num_100
Real number (ℝ)
High correlation  Zeros 
| Distinct | 271 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.005545 |
| Minimum | 0 |
|---|---|
| Maximum | 580 |
| Zeros | 484 |
| Zeros (%) | 2.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 215.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 16 |
| Q3 | 37 |
| 95-th percentile | 111 |
| Maximum | 580 |
| Range | 580 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 38.756431 |
|---|---|
| Coefficient of variation (CV) | 1.2916423 |
| Kurtosis | 15.744164 |
| Mean | 30.005545 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 3.0614821 |
| Sum | 551982 |
| Variance | 1502.061 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 778 | 4.2% |
| 4 | 707 | 3.8% |
| 3 | 662 | 3.6% |
| 2 | 658 | 3.6% |
| 5 | 640 | 3.5% |
| 6 | 601 | 3.3% |
| 8 | 586 | 3.2% |
| 7 | 576 | 3.1% |
| 10 | 544 | 3.0% |
| 9 | 508 | 2.8% |
| Other values (261) | 12136 |
| Value | Count | Frequency (%) |
| 0 | 484 | |
| 1 | 778 | |
| 2 | 658 | |
| 3 | 662 | |
| 4 | 707 | |
| 5 | 640 | |
| 6 | 601 | |
| 7 | 576 | |
| 8 | 586 | |
| 9 | 508 |
| Value | Count | Frequency (%) |
| 580 | 1 | |
| 487 | 1 | |
| 471 | 1 | |
| 456 | 2 | |
| 451 | 1 | |
| 422 | 1 | |
| 384 | 1 | |
| 379 | 1 | |
| 365 | 1 | |
| 361 | 1 |
num_unq
Real number (ℝ)
High correlation 
| Distinct | 231 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.123559 |
| Minimum | 1 |
|---|---|
| Maximum | 399 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 179.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 18 |
| Q3 | 38 |
| 95-th percentile | 97 |
| Maximum | 399 |
| Range | 398 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 32.194732 |
|---|---|
| Coefficient of variation (CV) | 1.1054532 |
| Kurtosis | 9.5023537 |
| Mean | 29.123559 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 2.4647719 |
| Sum | 535757 |
| Variance | 1036.5008 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 807 | 4.4% |
| 2 | 650 | 3.5% |
| 4 | 611 | 3.3% |
| 3 | 586 | 3.2% |
| 5 | 580 | 3.2% |
| 8 | 561 | 3.0% |
| 7 | 560 | 3.0% |
| 10 | 541 | 2.9% |
| 6 | 538 | 2.9% |
| 9 | 486 | 2.6% |
| Other values (221) | 12476 |
| Value | Count | Frequency (%) |
| 1 | 807 | |
| 2 | 650 | |
| 3 | 586 | |
| 4 | 611 | |
| 5 | 580 | |
| 6 | 538 | |
| 7 | 560 | |
| 8 | 561 | |
| 9 | 486 | |
| 10 | 541 |
| Value | Count | Frequency (%) |
| 399 | 1 | |
| 364 | 1 | |
| 334 | 1 | |
| 333 | 1 | |
| 312 | 1 | |
| 295 | 1 | |
| 293 | 1 | |
| 291 | 1 | |
| 287 | 1 | |
| 285 | 1 |
total_secs
Real number (ℝ)
High correlation 
| Distinct | 18264 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7847.7317 |
| Minimum | 0.287 |
|---|---|
| Maximum | 113437.88 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 215.6 KiB |
Quantile statistics
| Minimum | 0.287 |
|---|---|
| 5-th percentile | 416.02201 |
| Q1 | 1932.0125 |
| median | 4507.7861 |
| Q3 | 9781.4348 |
| 95-th percentile | 28251.478 |
| Maximum | 113437.88 |
| Range | 113437.59 |
| Interquartile range (IQR) | 7849.4223 |
Descriptive statistics
| Standard deviation | 9473.6768 |
|---|---|
| Coefficient of variation (CV) | 1.2071866 |
| Kurtosis | 9.701086 |
| Mean | 7847.7317 |
| Median Absolute Deviation (MAD) | 3174.3303 |
| Skewness | 2.6050677 |
| Sum | 1.4436687 × 108 |
| Variance | 89750544 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 247.6399994 | 6 | < 0.1% |
| 219 | 5 | < 0.1% |
| 261.223999 | 4 | < 0.1% |
| 245 | 4 | < 0.1% |
| 245.5740051 | 3 | < 0.1% |
| 2006 | 3 | < 0.1% |
| 280 | 3 | < 0.1% |
| 735 | 3 | < 0.1% |
| 256 | 3 | < 0.1% |
| 251 | 3 | < 0.1% |
| Other values (18254) | 18359 |
| Value | Count | Frequency (%) |
| 0.2870000005 | 1 | |
| 0.5289999843 | 1 | |
| 0.55400002 | 1 | |
| 0.7310000062 | 1 | |
| 1.08099997 | 1 | |
| 1.136999965 | 1 | |
| 1.207000017 | 1 | |
| 1.567000031 | 2 | |
| 1.593000054 | 1 | |
| 1.697999954 | 1 |
| Value | Count | Frequency (%) |
| 113437.875 | 1 | |
| 86680.0625 | 1 | |
| 86277.875 | 1 | |
| 85840 | 1 | |
| 85416.50781 | 1 | |
| 85105.22656 | 1 | |
| 82204.1875 | 1 | |
| 81671.70312 | 1 | |
| 81652.17188 | 1 | |
| 81483.5 | 1 |
Interactions
Correlations
| date | num_100 | num_25 | num_50 | num_75 | num_985 | num_unq | total_secs | |
|---|---|---|---|---|---|---|---|---|
| date | 1.000 | 0.010 | 0.020 | 0.003 | 0.001 | 0.006 | 0.014 | 0.010 |
| num_100 | 0.010 | 1.000 | 0.285 | 0.250 | 0.272 | 0.282 | 0.839 | 0.983 |
| num_25 | 0.020 | 0.285 | 1.000 | 0.557 | 0.488 | 0.480 | 0.524 | 0.350 |
| num_50 | 0.003 | 0.250 | 0.557 | 1.000 | 0.455 | 0.416 | 0.426 | 0.325 |
| num_75 | 0.001 | 0.272 | 0.488 | 0.455 | 1.000 | 0.403 | 0.404 | 0.345 |
| num_985 | 0.006 | 0.282 | 0.480 | 0.416 | 0.403 | 1.000 | 0.401 | 0.362 |
| num_unq | 0.014 | 0.839 | 0.524 | 0.426 | 0.404 | 0.401 | 1.000 | 0.873 |
| total_secs | 0.010 | 0.983 | 0.350 | 0.325 | 0.345 | 0.362 | 0.873 | 1.000 |
Missing values
Sample
| msno | date | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | |
|---|---|---|---|---|---|---|---|---|---|
| 8062169 | WvbtqrNMRNsw8d16Q8bXCnQ5Doy6EpRZJsJukiPiPQA= | 20170309 | 1 | 0 | 1 | 1 | 3 | 6 | 1242.812012 |
| 13343799 | 45G4M13aqDprqi2Qc94cqeKN3if+bYOtwX877yWSN78= | 20170326 | 0 | 0 | 1 | 1 | 7 | 7 | 2164.858887 |
| 7589253 | tYCa8ga3FGwCXQRUqhd/mf2tkVrzRIkT/FY/B1MKZVE= | 20170321 | 14 | 0 | 0 | 2 | 9 | 25 | 2691.107910 |
| 6095351 | iV5B5c2Mnm9J3/MYJhjcvdCGMb54O+ZmYwxzLlkh4HY= | 20170302 | 5 | 1 | 0 | 0 | 6 | 12 | 1508.790039 |
| 13859296 | v/zXD/h3eH0A/oomcOo24hPP+xjKvrBuCtA01gbUXQQ= | 20170316 | 1 | 1 | 0 | 0 | 10 | 12 | 2593.332031 |
| 3809066 | bY9ZrG+DXszUhOiGpieExVXO0Knyj2yMRxIb58qnXko= | 20170304 | 11 | 2 | 3 | 2 | 164 | 145 | 42875.652344 |
| 4358245 | LhrVcrU9Abgbje+5T17v8OrqYut8j6l3ruFobV7Jjko= | 20170329 | 0 | 0 | 0 | 0 | 4 | 4 | 1077.183960 |
| 15544009 | TwZeZfhR3GBdDgnj5sxTz/5i6syNokHayWIP60V/TdM= | 20170306 | 4 | 1 | 1 | 0 | 6 | 10 | 1701.588013 |
| 508878 | VWi1+9mZGiok+ioVzUXVzkJFPa5Jk7HjlnnddT1cAYQ= | 20170319 | 18 | 2 | 1 | 0 | 81 | 91 | 21271.046875 |
| 8432658 | TZEBCR88vUTAvp3coFoTfCi5sDY5TloypuG63NXte80= | 20170303 | 9 | 0 | 0 | 0 | 4 | 8 | 1063.875000 |
| msno | date | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | |
|---|---|---|---|---|---|---|---|---|---|
| 1634282 | jlW7InbX/3frDu931WPhw5j/SR4p/FxcJd9kEkyD/oE= | 20170325 | 10 | 3 | 0 | 1 | 17 | 28 | 5818.110840 |
| 15942545 | kWQdziv0cpvvs7JQXxl2eQ6bThLq6wd1D3PZwed1sXk= | 20170311 | 12 | 10 | 3 | 1 | 53 | 62 | 15821.320312 |
| 16540782 | zZgzSwC4U6rqIai9a5xp7Q1A7RT2N57yIhiZbkB24y0= | 20170305 | 8 | 4 | 1 | 2 | 9 | 20 | 3039.791016 |
| 18221828 | c+dla9srl9jkqcPPoddptkEmEffrf/we69chgIjKmVY= | 20170327 | 2 | 0 | 0 | 0 | 75 | 75 | 17061.246094 |
| 5101948 | YWxPiur0s9nhlXeOotfYMZwWI2ZEQfNPFbnkRgJVgXE= | 20170302 | 0 | 0 | 0 | 0 | 33 | 33 | 7056.446777 |
| 10290179 | 3xUv1NDdMxqY6blRHFCHiF6HpVBttbFqsAgmnXfuRc4= | 20170314 | 23 | 2 | 2 | 1 | 14 | 37 | 4262.214844 |
| 4748764 | uzHktlZdSSv/0QmsqNRpWMNoDX45E2121mMOpipJLZQ= | 20170317 | 0 | 0 | 0 | 0 | 34 | 30 | 9485.052734 |
| 12117141 | RF1iIhxrSRIjVj448+did/XwAkCtp8PUrpcRlj8y0m0= | 20170307 | 1 | 0 | 0 | 0 | 7 | 8 | 1869.670044 |
| 15152330 | 85fjQZRYZrehWklAYMuyYAty81b6JdsCdFX7hmMyeD4= | 20170320 | 1 | 0 | 0 | 0 | 22 | 20 | 3901.335938 |
| 6748790 | DX3FZEazcSCmmkZe/vcHL1kkyOlcHXRu+mSlcPz8dqk= | 20170324 | 2 | 2 | 2 | 2 | 1 | 9 | 1272.676025 |